package com.itheima.mapper;

import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

public interface ReportMapper {

    //从tb_member表的sex字段查询男女的总数
    @Select("select(case when sex='1' then '男' else '女' end) name,\n" +
            "count(*)value\n" +
            " from tb_member\n" +
            "group by sex")

    public List<Map>selectSetmealRate();
}
